﻿CREATE PROCEDURE [dbo].[proc_Project_Task_Getlist_MyCount]
	(
		@StartDate nvarchar(10),
		@EndDate nvarchar(10),
		@Stext nvarchar(50),
		@UserName nvarchar(50)
	)
AS
	Select Count(Id) From Project_Task
	Where ExecPerson=@UserName and Convert(nchar(10),CreateDate,120) between @StartDate and @EndDate and (@Stext='' Or CusName like '%'+@Stext+'%')

	RETURN
